Skip to main content

GetCols

Returns the ApiRange object that represents all the cells on the columns range.

Syntax

expression.GetCols(sRange);

expression - A variable that represents a ApiWorksheet class.

Parameters

NameRequired/OptionalData typeDefaultDescription
sRangeRequiredstringSpecifies the columns range in the string format.

Returns

ApiRange

Example

This example shows how to get the ApiRange object that represents all the cells on the columns range.

var oWorksheet = Api.GetActiveSheet();
var oCols = oWorksheet.GetCols("A1:C1");
oCols.SetFillColor(Api.CreateColorFromRGB(255, 213, 191));